DEBUG: query: select mountain_id,mountain_name,location,king_id,dwarf_name as king_name from mountain left join dwarf on king_id = dwarf_id DEBUG: query: SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED DEBUG: ProcessUtility: SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED DEBUG: query: select d.dwarf_id as dwarfid,d.dwarf_name as dwarfname,d.born as born,d.home_id as homeid,m.mountain_name as homename,d.spouse_id as spouseid,s.dwarf_name as spousename from dwarf d left join dwarf s on d.spouse_id = s.dwarf_id left join mountain m on d.home_id = m.mountain_id DEBUG: query: SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED DEBUG: ProcessUtility: SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED